Stellar Profile Report

Dataset statistics

Number of variables	18
Number of observations	12517
Missing cells	8
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.7 MiB
Average record size in memory	144.0 B

Variable types

Numeric	16
Categorical	2

Alerts

`rerun_ID` has constant value ""	Constant
`obj_ID` is highly overall correlated with `run_ID`	High correlation
`u` is highly overall correlated with `g` and 2 other fields	High correlation
`g` is highly overall correlated with `u` and 6 other fields	High correlation
`r` is highly overall correlated with `u` and 7 other fields	High correlation
`i` is highly overall correlated with `u` and 7 other fields	High correlation
`z` is highly overall correlated with `g` and 6 other fields	High correlation
`run_ID` is highly overall correlated with `obj_ID`	High correlation
`spec_obj_ID` is highly overall correlated with `g` and 5 other fields	High correlation
`redshift` is highly overall correlated with `r` and 3 other fields	High correlation
`plate` is highly overall correlated with `g` and 5 other fields	High correlation
`MJD` is highly overall correlated with `g` and 5 other fields	High correlation
`class` is highly overall correlated with `redshift`	High correlation
`alpha` has unique values	Unique
`delta` has unique values	Unique

Reproduction

Analysis started	2023-06-04 12:25:09.492376
Analysis finished	2023-06-04 12:26:31.312386
Duration	1 minute and 21.82 seconds
Software version	ydata-profiling vv4.2.0
Download configuration	config.json

obj_ID
Real number (ℝ)

Distinct	10592
Distinct (%)	84.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.237666 × 10¹⁸

Minimum	1.2376459 × 10¹⁸
Maximum	1.2376805 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1.2376459 × 10¹⁸
5-th percentile	1.2376518 × 10¹⁸
Q1	1.237661 × 10¹⁸
median	1.2376648 × 10¹⁸
Q3	1.2376711 × 10¹⁸
95-th percentile	1.2376803 × 10¹⁸
Maximum	1.2376805 × 10¹⁸
Range	3.4585772 × 10¹³
Interquartile range (IQR)	1.0106591 × 10¹³

Descriptive statistics

Standard deviation	8.4275987 × 10¹²
Coefficient of variation (CV)	6.8092677 × 10^-6
Kurtosis	-0.76084707
Mean	1.237666 × 10¹⁸
Median Absolute Deviation (MAD)	5.4916546 × 10¹²
Skewness	0.27699644
Sum	1.5491865 × 10²²
Variance	7.1024421 × 10²⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.237678803 × 10¹⁸	7	0.1%
1.237662302 × 10¹⁸	7	0.1%
1.237678858 × 10¹⁸	7	0.1%
1.237663785 × 10¹⁸	7	0.1%
1.237663783 × 10¹⁸	6	< 0.1%
1.237663783 × 10¹⁸	6	< 0.1%
1.237654391 × 10¹⁸	6	< 0.1%
1.237666302 × 10¹⁸	6	< 0.1%
1.237663459 × 10¹⁸	6	< 0.1%
1.237663463 × 10¹⁸	6	< 0.1%
Other values (10582)	12453	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237645944 × 10¹⁸	1	< 0.1%
1.237646382 × 10¹⁸	1	< 0.1%
1.237646382 × 10¹⁸	1	< 0.1%
1.237646792 × 10¹⁸	1	< 0.1%
1.237646794 × 10¹⁸	1	< 0.1%

Value	Count	Frequency (%)
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%
1.23768053 × 10¹⁸	1	< 0.1%

alpha
Real number (ℝ)

Distinct	12517
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	175.5333

Minimum	0.0055278279
Maximum	359.97429
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	0.0055278279
5-th percentile	7.6206176
Q1	119.45408
median	174.94648
Q3	239.2597
95-th percentile	350.35136
Maximum	359.97429
Range	359.96876
Interquartile range (IQR)	119.80563

Descriptive statistics

Standard deviation	104.50373
Coefficient of variation (CV)	0.59534988
Kurtosis	-0.81995498
Mean	175.5333
Median Absolute Deviation (MAD)	60.18119
Skewness	0.015735684
Sum	2197150.3
Variance	10921.03
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
135.6891066	1	< 0.1%
126.2736401	1	< 0.1%
117.8356583	1	< 0.1%
339.4422338	1	< 0.1%
342.9652278	1	< 0.1%
115.1640613	1	< 0.1%
248.2678019	1	< 0.1%
225.8383929	1	< 0.1%
153.4098326	1	< 0.1%
157.5426717	1	< 0.1%
Other values (12507)	12507	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005527827924	1	< 0.1%
0.01333666183	1	< 0.1%
0.02425788497	1	< 0.1%
0.05101121243	1	< 0.1%
0.07573854975	1	< 0.1%
0.08524942209	1	< 0.1%
0.0935691169	1	< 0.1%
0.10189313	1	< 0.1%
0.1063297907	1	< 0.1%
0.1072433545	1	< 0.1%

Value	Count	Frequency (%)
359.9742918	1	< 0.1%
359.9463159	1	< 0.1%
359.9398061	1	< 0.1%
359.9187627	1	< 0.1%
359.9108226	1	< 0.1%
359.8960375	1	< 0.1%
359.8894143	1	< 0.1%
359.8497258	1	< 0.1%
359.8430004	1	< 0.1%
359.8372293	1	< 0.1%

delta
Real number (ℝ)

Distinct	12517
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.589038

Minimum	-13.624327
Maximum	82.764421
Zeros	0
Zeros (%)	0.0%
Negative	1353
Negative (%)	10.8%
Memory size	97.9 KiB

Quantile statistics

Minimum	-13.624327
5-th percentile	-1.4925307
Q1	3.9259488
median	20.513758
Q3	37.26374
95-th percentile	55.293195
Maximum	82.764421
Range	96.388748
Interquartile range (IQR)	33.337791

Descriptive statistics

Standard deviation	18.847095
Coefficient of variation (CV)	0.83434697
Kurtosis	-0.9394861
Mean	22.589038
Median Absolute Deviation (MAD)	16.662008
Skewness	0.31716581
Sum	282746.99
Variance	355.213
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32.49463184	1	< 0.1%
45.53364552	1	< 0.1%
17.72492137	1	< 0.1%
1.096230054	1	< 0.1%
1.148783474	1	< 0.1%
41.23496726	1	< 0.1%
33.0921362	1	< 0.1%
36.94484135	1	< 0.1%
17.32546465	1	< 0.1%
17.91526358	1	< 0.1%
Other values (12507)	12507	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-13.6243266	1	< 0.1%
-12.68517141	1	< 0.1%
-12.41489591	1	< 0.1%
-12.35314572	1	< 0.1%
-12.02798014	1	< 0.1%
-11.80383484	1	< 0.1%
-11.40214597	1	< 0.1%
-11.2663831	1	< 0.1%
-10.77990673	1	< 0.1%
-10.60182346	1	< 0.1%

Value	Count	Frequency (%)
82.76442096	1	< 0.1%
82.28865698	1	< 0.1%
79.25912069	1	< 0.1%
79.17043583	1	< 0.1%
79.13027385	1	< 0.1%
78.69718864	1	< 0.1%
78.3167919	1	< 0.1%
77.76046377	1	< 0.1%
77.69637009	1	< 0.1%
77.36060713	1	< 0.1%

u
Real number (ℝ)

Distinct	12396
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.082509

Minimum	12.2624
Maximum	29.19901
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	12.2624
5-th percentile	18.500686
Q1	20.39184
median	22.14223
Q3	23.66948
95-th percentile	25.792438
Maximum	29.19901
Range	16.93661
Interquartile range (IQR)	3.27764

Descriptive statistics

Standard deviation	2.2357948
Coefficient of variation (CV)	0.10124732
Kurtosis	-0.48531881
Mean	22.082509
Median Absolute Deviation (MAD)	1.64533
Skewness	-0.047261655
Sum	276406.76
Variance	4.9987785
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.63465	14	0.1%
24.63466	6	< 0.1%
24.63468	4	< 0.1%
24.63471	2	< 0.1%
22.55928	2	< 0.1%
23.03799	2	< 0.1%
20.03177	2	< 0.1%
23.03029	2	< 0.1%
20.17831	2	< 0.1%
19.70649	2	< 0.1%
Other values (12386)	12479	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.2624	1	< 0.1%
14.50678	1	< 0.1%
15.35842	1	< 0.1%
15.38325	1	< 0.1%
15.4468	1	< 0.1%
15.47245	1	< 0.1%
15.58205	1	< 0.1%
15.61601	1	< 0.1%
15.61909	1	< 0.1%
15.62139	1	< 0.1%

Value	Count	Frequency (%)
29.19901	1	< 0.1%
28.90174	1	< 0.1%
27.80917	1	< 0.1%
27.8003	1	< 0.1%
27.69898	1	< 0.1%
27.63276	1	< 0.1%
27.55347	1	< 0.1%
27.53008	1	< 0.1%
27.4897	1	< 0.1%
27.4588	1	< 0.1%

g
Real number (ℝ)

Distinct	12408
Distinct (%)	99.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.634716

Minimum	10.51139
Maximum	28.9032
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	10.51139
5-th percentile	17.130086
Q1	19.04204
median	21.05874
Q3	22.10094
95-th percentile	23.408376
Maximum	28.9032
Range	18.39181
Interquartile range (IQR)	3.0589

Descriptive statistics

Standard deviation	2.0135861
Coefficient of variation (CV)	0.097582445
Kurtosis	-0.27669028
Mean	20.634716
Median Absolute Deviation (MAD)	1.31724
Skewness	-0.42133744
Sum	258284.74
Variance	4.0545288
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.14258	3	< 0.1%
22.2753	2	< 0.1%
20.77017	2	< 0.1%
18.20431	2	< 0.1%
21.45683	2	< 0.1%
20.60398	2	< 0.1%
18.62643	2	< 0.1%
21.67759	2	< 0.1%
21.23085	2	< 0.1%
17.99198	2	< 0.1%
Other values (12398)	12496	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.51139	1	< 0.1%
12.67902	1	< 0.1%
13.73052	1	< 0.1%
13.8347	1	< 0.1%
13.88656	1	< 0.1%
14.02731	1	< 0.1%
14.1092	1	< 0.1%
14.11843	1	< 0.1%
14.30195	1	< 0.1%
14.37224	1	< 0.1%

Value	Count	Frequency (%)
28.9032	1	< 0.1%
27.26466	1	< 0.1%
27.15748	1	< 0.1%
27.07299	1	< 0.1%
26.88175	1	< 0.1%
26.77787	1	< 0.1%
26.53025	1	< 0.1%
26.44887	1	< 0.1%
26.39754	1	< 0.1%
26.3144	1	< 0.1%

r
Real number (ℝ)

Distinct	12376
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.666776

Minimum	10.06854
Maximum	27.39709
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	10.06854
5-th percentile	16.428314
Q1	18.21046
median	20.13639
Q3	21.05019
95-th percentile	22.087562
Maximum	27.39709
Range	17.32855
Interquartile range (IQR)	2.83973

Descriptive statistics

Standard deviation	1.8415992
Coefficient of variation (CV)	0.093640117
Kurtosis	-0.33040625
Mean	19.666776
Median Absolute Deviation (MAD)	1.22932
Skewness	-0.51659383
Sum	246169.03
Variance	3.3914876
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.95005	2	< 0.1%
17.32595	2	< 0.1%
20.08151	2	< 0.1%
18.19844	2	< 0.1%
17.62665	2	< 0.1%
19.76283	2	< 0.1%
20.6039	2	< 0.1%
20.10729	2	< 0.1%
20.72109	2	< 0.1%
22.47901	2	< 0.1%
Other values (12366)	12497	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.06854	1	< 0.1%
11.74664	1	< 0.1%
12.80579	1	< 0.1%
12.86339	1	< 0.1%
13.06969	1	< 0.1%
13.20467	1	< 0.1%
13.20538	1	< 0.1%
13.40388	1	< 0.1%
13.45793	1	< 0.1%
13.61539	1	< 0.1%

Value	Count	Frequency (%)
27.39709	1	< 0.1%
27.33476	1	< 0.1%
25.22189	1	< 0.1%
24.92102	1	< 0.1%
24.81002	1	< 0.1%
24.8026	1	< 0.1%
24.80203	2	< 0.1%
24.80202	2	< 0.1%
24.80159	1	< 0.1%
24.76983	1	< 0.1%

i
Real number (ℝ)

Distinct	12384
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.118716

Minimum	11.29956
Maximum	30.1546
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	11.29956
5-th percentile	16.05422
Q1	17.79078
median	19.44152
Q3	20.44477
95-th percentile	21.62574
Maximum	30.1546
Range	18.85504
Interquartile range (IQR)	2.65399

Descriptive statistics

Standard deviation	1.7555926
Coefficient of variation (CV)	0.091825862
Kurtosis	-0.25412527
Mean	19.118716
Median Absolute Deviation (MAD)	1.20771
Skewness	-0.42513524
Sum	239308.97
Variance	3.0821052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.04249	3	< 0.1%
20.7219	3	< 0.1%
18.51546	3	< 0.1%
19.16573	2	< 0.1%
18.94915	2	< 0.1%
19.01537	2	< 0.1%
18.99609	2	< 0.1%
17.23952	2	< 0.1%
19.70479	2	< 0.1%
17.83562	2	< 0.1%
Other values (12374)	12494	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11.29956	1	< 0.1%
12.22783	1	< 0.1%
12.41727	1	< 0.1%
12.68676	1	< 0.1%
12.73416	1	< 0.1%
12.80524	1	< 0.1%
13.00044	1	< 0.1%
13.03615	1	< 0.1%
13.10743	1	< 0.1%
13.21151	1	< 0.1%

Value	Count	Frequency (%)
30.1546	1	< 0.1%
24.78471	1	< 0.1%
24.6315	1	< 0.1%
24.47336	1	< 0.1%
24.36193	1	< 0.1%
24.36182	1	< 0.1%
24.36181	1	< 0.1%
24.3618	1	< 0.1%
23.80095	1	< 0.1%
23.69384	1	< 0.1%

z
Real number (ℝ)

Distinct	12383
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.808766

Minimum	10.22551
Maximum	26.42779
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	10.22551
5-th percentile	15.781204
Q1	17.51829
median	19.04271
Q3	19.96365
95-th percentile	21.496052
Maximum	26.42779
Range	16.20228
Interquartile range (IQR)	2.44536

Descriptive statistics

Standard deviation	1.7743137
Coefficient of variation (CV)	0.094334398
Kurtosis	-0.19453224
Mean	18.808766
Median Absolute Deviation (MAD)	1.18575
Skewness	-0.26934744
Sum	235429.33
Variance	3.1481889
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22.8269	14	0.1%
19.8066	3	< 0.1%
19.6901	2	< 0.1%
19.55999	2	< 0.1%
16.03147	2	< 0.1%
19.26989	2	< 0.1%
17.97244	2	< 0.1%
16.90271	2	< 0.1%
17.84232	2	< 0.1%
19.53197	2	< 0.1%
Other values (12373)	12484	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10.22551	1	< 0.1%
10.91847	1	< 0.1%
11.78913	1	< 0.1%
12.1256	1	< 0.1%
12.39726	1	< 0.1%
12.40214	1	< 0.1%
12.42432	1	< 0.1%
12.51869	1	< 0.1%
12.69585	1	< 0.1%
12.71279	1	< 0.1%

Value	Count	Frequency (%)
26.42779	1	< 0.1%
25.33364	1	< 0.1%
24.78273	1	< 0.1%
24.39331	1	< 0.1%
24.24891	1	< 0.1%
24.21933	1	< 0.1%
24.00087	1	< 0.1%
23.99034	1	< 0.1%
23.81899	1	< 0.1%
23.75511	1	< 0.1%

run_ID
Real number (ℝ)

Distinct	247
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4767.6645

Minimum	109
Maximum	8162
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	109
5-th percentile	1462
Q1	3606
median	4504
Q3	5959
95-th percentile	8102
Maximum	8162
Range	8053
Interquartile range (IQR)	2353

Descriptive statistics

Standard deviation	1962.2261
Coefficient of variation (CV)	0.41156968
Kurtosis	-0.76082797
Mean	4767.6645
Median Absolute Deviation (MAD)	1279
Skewness	0.27701437
Sum	59676856
Variance	3850331.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4263	591	4.7%
7773	517	4.1%
5935	354	2.8%
4649	327	2.6%
3699	323	2.6%
7712	306	2.4%
8103	278	2.2%
4849	278	2.2%
6573	260	2.1%
3927	213	1.7%
Other values (237)	9070	72.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
109	6	< 0.1%
211	2	< 0.1%
307	2	< 0.1%
308	8	0.1%
745	9	0.1%
752	23	0.2%
756	20	0.2%
1140	58	0.5%
1231	11	0.1%
1239	64	0.5%

Value	Count	Frequency (%)
8162	10	0.1%
8157	20	0.2%
8156	19	0.2%
8155	4	< 0.1%
8150	1	< 0.1%
8116	41	0.3%
8115	7	0.1%
8112	41	0.3%
8111	17	0.1%
8110	9	0.1%

rerun_ID
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	97.9 KiB

301	12517

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	37551
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	301
2nd row	301
3rd row	301
4th row	301
5th row	301

Common Values

Value	Count	Frequency (%)
301	12517	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
301	12517	100.0%

Most occurring characters

Value	Count	Frequency (%)
3	12517	33.3%
0	12517	33.3%
1	12517	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	37551	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	12517	33.3%
0	12517	33.3%
1	12517	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	37551	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	12517	33.3%
0	12517	33.3%
1	12517	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37551	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	12517	33.3%
0	12517	33.3%
1	12517	33.3%

cam_col
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.5207734

Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	4
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.5406491
Coefficient of variation (CV)	0.43758825
Kurtosis	-1.0922786
Mean	3.5207734
Median Absolute Deviation (MAD)	1
Skewness	-0.029926008
Sum	44066
Variance	2.3735996
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
4	2800	22.4%
2	2542	20.3%
5	2346	18.7%
3	2027	16.2%
6	1434	11.5%
1	1367	10.9%
(Missing)	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1367	10.9%
2	2542	20.3%
3	2027	16.2%
4	2800	22.4%
5	2346	18.7%
6	1434	11.5%

Value	Count	Frequency (%)
6	1434	11.5%
5	2346	18.7%
4	2800	22.4%
3	2027	16.2%
2	2542	20.3%
1	1367	10.9%

field_ID
Real number (ℝ)

Distinct	694
Distinct (%)	5.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	186.15252

Minimum	11
Maximum	847
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	11
5-th percentile	32
Q1	81
median	148
Q3	239
95-th percentile	463
Maximum	847
Range	836
Interquartile range (IQR)	158

Descriptive statistics

Standard deviation	150.08428
Coefficient of variation (CV)	0.80624357
Kurtosis	4.7754972
Mean	186.15252
Median Absolute Deviation (MAD)	75
Skewness	1.9221308
Sum	2329885
Variance	22525.29
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
69	81	0.6%
68	69	0.6%
58	68	0.5%
61	65	0.5%
74	65	0.5%
60	64	0.5%
57	63	0.5%
52	62	0.5%
104	62	0.5%
65	62	0.5%
Other values (684)	11855	94.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
11	15	0.1%
12	20	0.2%
13	13	0.1%
14	20	0.2%
15	15	0.1%
16	33	0.3%
17	20	0.2%
18	33	0.3%
19	29	0.2%
20	26	0.2%

Value	Count	Frequency (%)
847	1	< 0.1%
846	2	< 0.1%
845	2	< 0.1%
844	2	< 0.1%
843	3	< 0.1%
842	2	< 0.1%
841	1	< 0.1%
840	1	< 0.1%
839	5	< 0.1%
838	1	< 0.1%

spec_obj_ID
Real number (ℝ)

Distinct	12516
Distinct (%)	100.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5.7795909 × 10¹⁸

Minimum	2.9957929 × 10¹⁷
Maximum	1.4126851 × 10¹⁹
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	2.9957929 × 10¹⁷
5-th percentile	8.0140073 × 10¹⁷
Q1	2.7528765 × 10¹⁸
median	5.6611781 × 10¹⁸
Q3	8.3396895 × 10¹⁸
95-th percentile	1.1555313 × 10¹⁹
Maximum	1.4126851 × 10¹⁹
Range	1.3827272 × 10¹⁹
Interquartile range (IQR)	5.586813 × 10¹⁸

Descriptive statistics

Standard deviation	3.3143284 × 10¹⁸
Coefficient of variation (CV)	0.57345381
Kurtosis	-0.88008533
Mean	5.7795909 × 10¹⁸
Median Absolute Deviation (MAD)	2.7619093 × 10¹⁸
Skewness	0.19126475
Sum	7.233736 × 10²²
Variance	1.0984773 × 10³⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6.543777369 × 10¹⁸	1	< 0.1%
7.197931812 × 10¹⁸	1	< 0.1%
1.249999379 × 10¹⁹	1	< 0.1%
1.032458749 × 10¹⁹	1	< 0.1%
1.032563588 × 10¹⁹	1	< 0.1%
3.559032633 × 10¹⁸	1	< 0.1%
1.22882383 × 10¹⁹	1	< 0.1%
1.522271697 × 10¹⁸	1	< 0.1%
6.003555689 × 10¹⁸	1	< 0.1%
6.014773732 × 10¹⁸	1	< 0.1%
Other values (12506)	12506	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2.995792876 × 10¹⁷	1	< 0.1%
2.995908325 × 10¹⁷	1	< 0.1%
2.995935813 × 10¹⁷	1	< 0.1%
2.99643884 × 10¹⁷	1	< 0.1%
3.007620869 × 10¹⁷	1	< 0.1%
3.175296401 × 10¹⁷	1	< 0.1%
3.334423276 × 10¹⁷	1	< 0.1%
3.344022008 × 10¹⁷	1	< 0.1%
3.344222669 × 10¹⁷	1	< 0.1%
3.344788917 × 10¹⁷	1	< 0.1%

Value	Count	Frequency (%)
1.4126851 × 10¹⁹	1	< 0.1%
1.41268411 × 10¹⁹	1	< 0.1%
1.412683808 × 10¹⁹	1	< 0.1%
1.41245937 × 10¹⁹	1	< 0.1%
1.412456319 × 10¹⁹	1	< 0.1%
1.412355439 × 10¹⁹	1	< 0.1%
1.412349199 × 10¹⁹	1	< 0.1%
1.41234065 × 10¹⁹	1	< 0.1%
1.412339771 × 10¹⁹	1	< 0.1%
1.412337572 × 10¹⁹	1	< 0.1%

class
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	97.9 KiB

GALAXY	7374
STAR	2657
QSO	2485

Length

Max length	6
Median length	6
Mean length	4.9797859
Min length	3

Characters and Unicode

Total characters	62327
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GALAXY
2nd row	GALAXY
3rd row	GALAXY
4th row	GALAXY
5th row	GALAXY

Common Values

Value	Count	Frequency (%)
GALAXY	7374	58.9%
STAR	2657	21.2%
QSO	2485	19.9%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
galaxy	7374	58.9%
star	2657	21.2%
qso	2485	19.9%

Most occurring characters

Value	Count	Frequency (%)
A	17405	27.9%
G	7374	11.8%
L	7374	11.8%
X	7374	11.8%
Y	7374	11.8%
S	5142	8.3%
T	2657	4.3%
R	2657	4.3%
Q	2485	4.0%
O	2485	4.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	62327	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	17405	27.9%
G	7374	11.8%
L	7374	11.8%
X	7374	11.8%
Y	7374	11.8%
S	5142	8.3%
T	2657	4.3%
R	2657	4.3%
Q	2485	4.0%
O	2485	4.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	62327	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	17405	27.9%
G	7374	11.8%
L	7374	11.8%
X	7374	11.8%
Y	7374	11.8%
S	5142	8.3%
T	2657	4.3%
R	2657	4.3%
Q	2485	4.0%
O	2485	4.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	62327	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	17405	27.9%
G	7374	11.8%
L	7374	11.8%
X	7374	11.8%
Y	7374	11.8%
S	5142	8.3%
T	2657	4.3%
R	2657	4.3%
Q	2485	4.0%
O	2485	4.0%

redshift
Real number (ℝ)

Distinct	12454
Distinct (%)	99.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	0.58501153

Minimum	-0.006863183
Maximum	7.011245
Zeros	57
Zeros (%)	0.5%
Negative	1726
Negative (%)	13.8%
Memory size	97.9 KiB

Quantile statistics

Minimum	-0.006863183
5-th percentile	-0.00030750335
Q1	0.057747163
median	0.39966045
Q3	0.7147072
95-th percentile	2.247079
Maximum	7.011245
Range	7.0181082
Interquartile range (IQR)	0.65696004

Descriptive statistics

Standard deviation	0.75014327
Coefficient of variation (CV)	1.2822709
Kurtosis	9.765086
Mean	0.58501153
Median Absolute Deviation (MAD)	0.3342527
Skewness	2.50049
Sum	7322.0043
Variance	0.56271493
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	57	0.5%
0.1157107	2	< 0.1%
1.064356	2	< 0.1%
-0.0001203588	2	< 0.1%
0.1320406	2	< 0.1%
0.5536857	2	< 0.1%
0.5918089	2	< 0.1%
0.6347936	1	< 0.1%
0.7403097	1	< 0.1%
0.4734564	1	< 0.1%
Other values (12444)	12444	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-0.006863183	1	< 0.1%
-0.004136078	1	< 0.1%
-0.004020127	1	< 0.1%
-0.004016399	1	< 0.1%
-0.003844469	1	< 0.1%
-0.003554939	1	< 0.1%
-0.003324229	1	< 0.1%
-0.003317097	1	< 0.1%
-0.003153456	1	< 0.1%
-0.002675624	1	< 0.1%

Value	Count	Frequency (%)
7.011245	1	< 0.1%
7.010263	1	< 0.1%
7.00387	1	< 0.1%
6.983865	1	< 0.1%
6.924236	1	< 0.1%
6.919427	1	< 0.1%
6.708698	1	< 0.1%
6.690471	1	< 0.1%
6.543818	1	< 0.1%
6.504732	1	< 0.1%

plate
Real number (ℝ)

Distinct	3558
Distinct (%)	28.4%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	5133.1984

Minimum	266
Maximum	12547
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	266
5-th percentile	711.75
Q1	2445
median	5028
Q3	7407
95-th percentile	10263
Maximum	12547
Range	12281
Interquartile range (IQR)	4962

Descriptive statistics

Standard deviation	2943.7011
Coefficient of variation (CV)	0.57346335
Kurtosis	-0.88007765
Mean	5133.1984
Median Absolute Deviation (MAD)	2453
Skewness	0.19127403
Sum	64247111
Variance	8665376.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6280	26	0.2%
6380	25	0.2%
8491	24	0.2%
8278	22	0.2%
6516	22	0.2%
7407	22	0.2%
6154	21	0.2%
5310	21	0.2%
9547	21	0.2%
7662	21	0.2%
Other values (3548)	12291	98.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
266	4	< 0.1%
267	1	< 0.1%
282	1	< 0.1%
296	1	< 0.1%
297	3	< 0.1%
298	2	< 0.1%
299	2	< 0.1%
308	1	< 0.1%
324	1	< 0.1%
326	3	< 0.1%

Value	Count	Frequency (%)
12547	3	< 0.1%
12545	2	< 0.1%
12544	5	< 0.1%
12533	2	< 0.1%
12531	12	0.1%
12527	4	< 0.1%
12525	7	0.1%
11653	1	< 0.1%
11651	4	< 0.1%
11649	1	< 0.1%

MJD
Real number (ℝ)

Distinct	1729
Distinct (%)	13.8%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	55584.48

Minimum	51608
Maximum	58932
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	51608
5-th percentile	52289
Q1	54180
median	55912
Q3	56781
95-th percentile	58199
Maximum	58932
Range	7324
Interquartile range (IQR)	2601

Descriptive statistics

Standard deviation	1804.854
Coefficient of variation (CV)	0.032470466
Kurtosis	-0.74887556
Mean	55584.48
Median Absolute Deviation (MAD)	1278
Skewness	-0.3944991
Sum	6.9569535 × 10⁸
Variance	3257497.8
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56269	46	0.4%
56340	41	0.3%
56187	38	0.3%
57358	38	0.3%
55831	38	0.3%
56570	36	0.3%
56214	33	0.3%
57488	33	0.3%
55481	33	0.3%
58462	32	0.3%
Other values (1719)	12148	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51608	1	< 0.1%
51630	4	< 0.1%
51658	1	< 0.1%
51662	1	< 0.1%
51666	1	< 0.1%
51671	7	0.1%
51690	1	< 0.1%
51691	2	< 0.1%
51692	4	< 0.1%
51693	9	0.1%

Value	Count	Frequency (%)
58932	19	0.2%
58931	2	< 0.1%
58930	6	< 0.1%
58928	8	0.1%
58543	9	0.1%
58526	3	< 0.1%
58523	3	< 0.1%
58522	13	0.1%
58515	2	< 0.1%
58514	10	0.1%

fiber_ID
Real number (ℝ)

Distinct	998
Distinct (%)	8.0%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	448.45454

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	97.9 KiB

Quantile statistics

Minimum	1
5-th percentile	47
Q1	225
median	437
Q3	637
95-th percentile	920
Maximum	1000
Range	999
Interquartile range (IQR)	412

Descriptive statistics

Standard deviation	267.75301
Coefficient of variation (CV)	0.59705721
Kurtosis	-0.93998267
Mean	448.45454
Median Absolute Deviation (MAD)	206
Skewness	0.21933647
Sum	5612857
Variance	71691.676
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
321	33	0.3%
340	29	0.2%
458	28	0.2%
631	27	0.2%
637	27	0.2%
457	26	0.2%
412	26	0.2%
639	26	0.2%
584	26	0.2%
619	25	0.2%
Other values (988)	12243	97.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	11	0.1%
2	16	0.1%
3	15	0.1%
4	8	0.1%
5	15	0.1%
6	7	0.1%
7	15	0.1%
8	15	0.1%
9	14	0.1%
10	12	0.1%

Value	Count	Frequency (%)
1000	8	0.1%
999	11	0.1%
998	2	< 0.1%
997	8	0.1%
996	6	< 0.1%
995	3	< 0.1%
994	7	0.1%
993	9	0.1%
992	9	0.1%
991	7	0.1%

Auto

Heatmap
Table

	obj_ID	alpha	delta	u	g	r	i	z	run_ID	cam_col	field_ID	spec_obj_ID	redshift	plate	MJD	fiber_ID	class
obj_ID	1.000	0.022	-0.298	0.091	0.084	0.080	0.074	0.070	1.000	-0.108	0.146	0.178	0.052	0.178	0.177	0.016	0.190
alpha	0.022	1.000	0.125	0.025	0.009	0.005	0.001	-0.001	0.023	0.069	-0.219	0.033	-0.003	0.033	0.046	0.057	0.149
delta	-0.298	0.125	1.000	-0.017	0.009	0.023	0.028	0.026	-0.299	0.026	-0.200	0.168	0.025	0.168	0.183	0.063	0.104
u	0.091	0.025	-0.017	1.000	0.848	0.683	0.554	0.486	0.091	0.014	0.005	0.400	0.314	0.400	0.398	0.156	0.287
g	0.084	0.009	0.009	0.848	1.000	0.905	0.785	0.709	0.083	0.016	-0.009	0.578	0.494	0.578	0.576	0.176	0.281
r	0.080	0.005	0.023	0.683	0.905	1.000	0.956	0.906	0.080	-0.004	-0.036	0.672	0.554	0.672	0.669	0.177	0.224
i	0.074	0.001	0.028	0.554	0.785	0.956	1.000	0.975	0.074	-0.017	-0.045	0.677	0.564	0.677	0.674	0.175	0.280
z	0.070	-0.001	0.026	0.486	0.709	0.906	0.975	1.000	0.069	-0.021	-0.047	0.655	0.549	0.654	0.650	0.171	0.357
run_ID	1.000	0.023	-0.299	0.091	0.083	0.080	0.074	0.069	1.000	-0.116	0.141	0.178	0.051	0.178	0.176	0.014	0.190
cam_col	-0.108	0.069	0.026	0.014	0.016	-0.004	-0.017	-0.021	-0.116	1.000	-0.014	-0.060	-0.027	-0.060	-0.065	0.132	0.071
field_ID	0.146	-0.219	-0.200	0.005	-0.009	-0.036	-0.045	-0.047	0.141	-0.014	1.000	-0.060	0.010	-0.060	-0.068	-0.031	0.103
spec_obj_ID	0.178	0.033	0.168	0.400	0.578	0.672	0.677	0.655	0.178	-0.060	-0.060	1.000	0.474	1.000	0.992	0.202	0.316
redshift	0.052	-0.003	0.025	0.314	0.494	0.554	0.564	0.549	0.051	-0.027	0.010	0.474	1.000	0.474	0.472	0.133	0.585
plate	0.178	0.033	0.168	0.400	0.578	0.672	0.677	0.654	0.178	-0.060	-0.060	1.000	0.474	1.000	0.992	0.202	0.316
MJD	0.177	0.046	0.183	0.398	0.576	0.669	0.674	0.650	0.176	-0.065	-0.068	0.992	0.472	0.992	1.000	0.203	0.325
fiber_ID	0.016	0.057	0.063	0.156	0.176	0.177	0.175	0.171	0.014	0.132	-0.031	0.202	0.133	0.202	0.203	1.000	0.082
class	0.190	0.149	0.104	0.287	0.281	0.224	0.280	0.357	0.190	0.071	0.103	0.316	0.585	0.316	0.325	0.082	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	obj_ID	alpha	delta	u	g	r	i	z	run_ID	rerun_ID	cam_col	field_ID	spec_obj_ID	class	redshift	plate	MJD	fiber_ID
0	1.237661e+18	135.689107	32.494632	23.87882	22.27530	20.39501	19.16573	18.79371	3606	301	2.0	79.0	6.543777e+18	GALAXY	0.634794	5812.0	56354.0	171.0
1	1.237665e+18	144.826101	31.274185	24.77759	22.83188	22.58444	21.16812	21.61427	4518	301	5.0	119.0	1.176014e+19	GALAXY	0.779136	10445.0	58158.0	427.0
2	1.237661e+18	142.188790	35.582444	25.26307	22.66389	20.60976	19.34857	18.94827	3606	301	2.0	120.0	5.152200e+18	GALAXY	0.644195	4576.0	55592.0	299.0
3	1.237663e+18	338.741038	-0.402828	22.13682	23.77656	21.61162	20.50454	19.25010	4192	301	3.0	214.0	1.030107e+19	GALAXY	0.932346	9149.0	58039.0	775.0
4	1.237680e+18	345.282593	21.183866	19.43718	17.58028	16.49747	15.97711	15.54461	8102	301	3.0	137.0	6.891865e+18	GALAXY	0.116123	6121.0	56187.0	842.0
5	1.237680e+18	340.995121	20.589476	23.48827	23.33776	21.32195	20.25615	19.54544	8102	301	3.0	110.0	5.658977e+18	QSO	1.424659	5026.0	55855.0	741.0
6	1.237679e+18	23.234926	11.418188	21.46973	21.17624	20.92829	20.60826	20.42573	7773	301	2.0	462.0	1.246262e+19	QSO	0.586455	11069.0	58456.0	113.0
7	1.237679e+18	5.433176	12.065186	22.24979	22.02172	20.34126	19.48794	18.84999	7773	301	2.0	346.0	6.961443e+18	GALAXY	0.477009	6183.0	56210.0	15.0
8	1.237661e+18	200.290475	47.199402	24.40286	22.35669	20.61032	19.46490	18.95852	3716	301	5.0	108.0	7.459285e+18	GALAXY	0.660012	6625.0	56386.0	719.0
9	1.237671e+18	39.149691	28.102842	21.74669	20.03493	19.17553	18.81823	18.65422	5934	301	4.0	122.0	2.751763e+18	STAR	-0.000008	2444.0	54082.0	232.0

	obj_ID	alpha	delta	u	g	r	i	z	run_ID	rerun_ID	cam_col	field_ID	spec_obj_ID	class	redshift	plate	MJD	fiber_ID
12507	1.237652e+18	167.527494	66.925504	25.52090	21.90391	20.34708	19.54722	19.42625	1412	301	4.0	124.0	8.006473e+18	GALAXY	0.436371	7111.0	56741.0	723.0
12508	1.237659e+18	243.545096	42.441566	23.22719	20.98145	18.84140	18.31056	18.05357	3225	301	4.0	211.0	1.317310e+18	STAR	-0.000094	1170.0	52756.0	24.0
12509	1.237679e+18	319.763413	1.159248	21.29047	19.99059	19.64603	19.59863	19.64684	7712	301	2.0	61.0	4.719988e+18	QSO	2.824225	4192.0	55469.0	784.0
12510	1.237662e+18	239.934588	28.482919	22.71141	21.36372	19.76699	18.94249	18.48801	3919	301	5.0	234.0	5.320102e+18	GALAXY	0.462970	4725.0	55711.0	817.0
12511	1.237671e+18	143.356310	15.413859	19.45343	19.18156	19.09905	18.87353	18.98130	5935	301	4.0	181.0	1.079198e+19	QSO	1.573556	9585.0	57780.0	839.0
12512	1.237665e+18	187.107343	29.240731	17.16930	16.10525	16.04771	16.09128	16.15915	4649	301	2.0	38.0	2.515321e+18	STAR	0.000417	2234.0	53823.0	222.0
12513	1.237662e+18	169.336383	41.349718	20.11149	19.23186	18.96544	18.87794	18.84636	3893	301	3.0	97.0	3.744904e+18	STAR	-0.000147	3326.0	54943.0	584.0
12514	1.237662e+18	170.435300	41.459497	22.04947	22.11426	21.75022	21.67448	21.18440	3893	301	3.0	102.0	9.420409e+18	QSO	1.243781	8367.0	57429.0	16.0
12515	1.237651e+18	127.807909	1.013425	25.27475	22.46262	20.72712	19.58966	19.15112	1239	301	6.0	50.0	5.394425e+18	GALAXY	0.625881	4791.0	55889.0	867.0
12516	1.237651e+18	143.957394	1.025136	21.91836	21.62359	20.02692	19.16573	18.67867	1239	301	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample